[dbo].[asi_GroupMembershipCount]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.asi_GroupMembershipCount
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@groupkey
uniqueidentifier
16
SQL Script
CREATE
PROCEDURE
[dbo]
.
[asi_GroupMembershipCount]
@groupkey
uniqueidentifier
AS
BEGIN
SELECT
COUNT
(
1
)
AS
MemberCount
FROM
GroupMember
WHERE
GroupKey
=
@groupkey
END
GO
Uses
[dbo].[GroupMember]
dbo